SELECT CONCAT(e.FirstName, ' ', e.MiddleName, ' ', e.LastName) AS [Employee name],
	CONCAT(m.FirstName, ' ', m.MiddleName, ' ', m.LastName) AS [Manager name],
	a.AddressText AS [Address], t.Name AS Town
	FROM Employees e
	JOIN Employees m
	ON e.ManagerID = m.EmployeeID
	JOIN Addresses a
	ON a.AddressID = m.AddressID
	JOIN Towns t
	ON t.TownID = a.AddressID